TTN Dashboard

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

Distance

68.1 cm

Temperature

32.8 °C

dds75-lb-02

Distance

78.5 cm

Temperature

32.8 °C

dds75-lb-03

Distance

85.1 cm

Temperature

32.8 °C

dds75-lb-04

Distance

85.1 cm

Temperature

32.8 °C

dds75-lb-05

Distance

69.7 cm

Temperature

32.8 °C

dds75-lb-06

Distance

68.5 cm

Temperature

32.8 °C

dds75-lb-07

Distance

86.9 cm

Temperature

32.8 °C

dds75-lb-08

Distance

83.3 cm

Temperature

32.8 °C

dds75-lb-09

Distance

0 cm

Temperature

32.8 °C

dds75-lb-10

Distance

71.9 cm

Temperature

32.8 °C

dds75-lb-11

Distance

89.9 cm

Temperature

32.8 °C

dds75-lb-12

Distance

87.1 cm

Temperature

32.8 °C

dds75-lb-13

Distance

92.5 cm

Temperature

32.8 °C

dds75-lb-14

Distance

121.4 cm

Temperature

32.8 °C

dds75-lb-15

Distance

97.7 cm

Temperature

32.8 °C

dds75-lb-16

Distance

71.8 cm

Temperature

32.8 °C

dds75-lb-17

Distance

218.3 cm

Temperature

32.8 °C

dds75-lb-18

Distance

89.7 cm

Temperature

32.8 °C

dds75-lb-19

Distance

68 cm

Temperature

32.8 °C

dds75-lb-20

Distance

92.5 cm

Temperature

32.8 °C

dds75-lb-21

Distance

72 cm

Temperature

32.8 °C

PS-LB

ps-lb-01

Water

0 cm

ps-lb-02

Water

18.8 cm

ps-lb-03

Water

20.1 cm

ps-lb-04

Water

19.9 cm

ps-lb-05

Water

22.4 cm

ps-lb-06

Water

20.3 cm

ps-lb-07

Water

20 cm

ps-lb-08

Water

20.8 cm

ps-lb-09

Water

21.8 cm

ps-lb-10

Water

19.5 cm

ps-lb-11

Water

19.2 cm

ps-lb-12

Water

21.9 cm

ps-lb-13

Water

19.5 cm

ps-lb-14

Water

18.1 cm

ps-lb-15

Water

21 cm

ps-lb-16

Water

20.2 cm

ps-lb-17

Water

20.6 cm

ps-lb-18

Water

20 cm

ps-lb-19

Water

22.2 cm

ps-lb-20

Water

20.7 cm

ps-lb-21

Water

21.3 cm

Geräte-Tabelle

device_id	records	last_seen_utc	status
dds75-lb-001	164	2025-09-20 06:23:34Z	ok
dds75-lb-02	162	2025-09-20 06:27:26Z	ok
dds75-lb-03	164	2025-09-20 06:21:35Z	ok
dds75-lb-04	164	2025-09-20 06:24:32Z	ok
dds75-lb-05	164	2025-09-20 06:23:59Z	ok
dds75-lb-06	164	2025-09-20 06:28:15Z	ok
dds75-lb-07	163	2025-09-20 06:24:48Z	ok
dds75-lb-08	164	2025-09-20 06:24:34Z	ok
dds75-lb-09	164	2025-09-20 06:24:36Z	ok
dds75-lb-10	164	2025-09-20 06:25:19Z	ok
dds75-lb-11	164	2025-09-20 06:25:00Z	ok
dds75-lb-12	163	2025-09-20 06:26:02Z	ok
dds75-lb-13	164	2025-09-20 06:27:15Z	ok
dds75-lb-14	164	2025-09-20 06:22:06Z	ok
dds75-lb-15	164	2025-09-20 06:23:04Z	ok
dds75-lb-16	164	2025-09-20 06:20:45Z	ok
dds75-lb-17	164	2025-09-20 06:23:37Z	ok
dds75-lb-18	164	2025-09-20 06:21:14Z	ok
dds75-lb-19	164	2025-09-20 06:25:45Z	ok
dds75-lb-20	162	2025-09-20 06:23:34Z	ok
dds75-lb-21	164	2025-09-20 06:23:44Z	ok
ps-lb-01	422	2025-09-20 06:33:14Z	ok
ps-lb-02	480	2025-09-20 06:30:09Z	ok
ps-lb-03	481	2025-09-20 06:30:19Z	ok
ps-lb-04	478	2025-09-20 06:29:43Z	ok
ps-lb-05	479	2025-09-20 06:30:01Z	ok
ps-lb-06	461	2025-09-20 06:29:40Z	ok
ps-lb-07	478	2025-09-20 06:29:56Z	ok
ps-lb-08	480	2025-09-20 06:29:30Z	ok
ps-lb-09	481	2025-09-20 06:29:27Z	ok
ps-lb-10	481	2025-09-20 06:30:04Z	ok
ps-lb-11	482	2025-09-20 06:30:02Z	ok
ps-lb-12	481	2025-09-20 06:29:33Z	ok
ps-lb-13	2346	2025-09-20 06:32:01Z	ok
ps-lb-14	479	2025-09-20 06:30:08Z	ok
ps-lb-15	481	2025-09-20 06:29:58Z	ok
ps-lb-16	483	2025-09-20 06:29:59Z	ok
ps-lb-17	2763	2025-09-20 06:35:59Z	ok
ps-lb-18	397	2025-09-20 06:32:08Z	ok
ps-lb-19	501	2025-09-20 06:30:33Z	ok
ps-lb-20	503	2025-09-20 06:34:04Z	ok
ps-lb-21	336	2025-09-20 06:29:12Z	ok
sensecap-01	0	NaN	empty

Parquet: data/<device>.parquet • CSV: data/<device>.csv • NDJSON (raw): data/<device>_raw.ndjson

dds75-lb-001

received_at	f_port	battery	rssi	snr
2025-09-20 05:23:35.476571437+00:00	2	3.303	-33	9.25
2025-09-20 05:43:35.247476486+00:00	2	3.303	-33	8.75
2025-09-20 06:03:35.011710831+00:00	2	3.303	-116	-0.50
2025-09-20 06:23:34.757627931+00:00	2	3.303	-35	9.25

dds75-lb-02

received_at	f_port	battery	rssi	snr
2025-09-20 05:07:27.568960853+00:00	2	3.212	-38	9.75
2025-09-20 05:27:27.287801704+00:00	2	3.212	-118	-3.75
2025-09-20 05:47:27.024324168+00:00	2	3.212	-39	10.50
2025-09-20 06:07:26.761015617+00:00	2	3.212	-37	8.75
2025-09-20 06:27:26.478104778+00:00	2	3.212	-39	9.75

dds75-lb-03

received_at	f_port	battery	rssi	snr
2025-09-20 05:21:36.261917737+00:00	2	3.29	-45	9.25
2025-09-20 05:41:36.009831307+00:00	2	3.29	-44	7.00
2025-09-20 06:01:35.777955728+00:00	2	3.29	-44	10.00
2025-09-20 06:21:35.551000146+00:00	2	3.29	-45	10.00

dds75-lb-04

received_at	f_port	battery	rssi	snr
2025-09-20 05:04:33.488731830+00:00	2	3.256	-51	7.25
2025-09-20 05:24:33.257246774+00:00	2	3.256	-49	7.25
2025-09-20 05:44:33.013456248+00:00	2	3.256	-51	8.25
2025-09-20 06:04:32.788244790+00:00	2	3.256	-53	10.00
2025-09-20 06:24:32.530179333+00:00	2	3.256	-50	8.75

dds75-lb-05

received_at	f_port	battery	rssi	snr
2025-09-20 05:04:00.699543098+00:00	2	3.301	-45	9.50
2025-09-20 05:24:00.469726199+00:00	2	3.301	-44	9.25
2025-09-20 05:44:00.218354869+00:00	2	3.301	-45	7.25
2025-09-20 06:03:59.999588745+00:00	2	3.301	-115	0.25
2025-09-20 06:23:59.750058520+00:00	2	3.301	-44	9.25

dds75-lb-06

received_at	f_port	battery	rssi	snr
2025-09-20 05:08:16.747629307+00:00	2	3.343	-40	8.00
2025-09-20 05:28:16.526580120+00:00	2	3.343	-41	9.75
2025-09-20 05:48:16.286899131+00:00	2	3.343	-43	9.00
2025-09-20 06:08:16.039892367+00:00	2	3.343	-41	8.75
2025-09-20 06:28:15.818143278+00:00	2	3.343	-39	9.25

dds75-lb-07

received_at	f_port	battery	rssi	snr
2025-09-20 05:04:49.518331439+00:00	2	3.257	-33	9.50
2025-09-20 05:24:49.276324192+00:00	2	3.257	-39	9.25
2025-09-20 05:44:49.064958903+00:00	2	3.257	-35	9.75
2025-09-20 06:04:48.817922827+00:00	2	3.257	-35	9.75
2025-09-20 06:24:48.580880897+00:00	2	3.257	-37	9.25

dds75-lb-08

received_at	f_port	battery	rssi	snr
2025-09-20 05:04:35.355065266+00:00	2	3.28	-35	10.00
2025-09-20 05:24:35.140915632+00:00	2	3.28	-35	9.25
2025-09-20 05:44:34.901019176+00:00	2	3.28	-117	-0.25
2025-09-20 06:04:34.677671600+00:00	2	3.28	-33	9.50
2025-09-20 06:24:34.445070753+00:00	2	3.28	-112	3.25

dds75-lb-09

received_at	f_port	battery	rssi	snr
2025-09-20 05:04:37.309256104+00:00	2	3.332	-48	7.00
2025-09-20 05:24:37.074720496+00:00	2	3.332	-57	7.00
2025-09-20 05:44:36.866390293+00:00	2	3.332	-51	9.25
2025-09-20 06:04:36.648517754+00:00	2	3.332	-48	9.50
2025-09-20 06:24:36.420435290+00:00	2	3.332	-50	9.00

dds75-lb-10

received_at	f_port	battery	rssi	snr
2025-09-20 05:05:20.849646299+00:00	2	3.357	-36	8.75
2025-09-20 05:25:20.616378413+00:00	2	3.357	-38	10.00
2025-09-20 05:45:20.382799309+00:00	2	3.357	-112	-0.50
2025-09-20 06:05:20.160874868+00:00	2	3.357	-35	10.25
2025-09-20 06:25:19.938439623+00:00	2	3.357	-36	9.50

dds75-lb-11

received_at	f_port	battery	rssi	snr
2025-09-20 05:05:01.148415636+00:00	2	3.299	-36	9.00
2025-09-20 05:25:00.926226925+00:00	2	3.299	-38	9.25
2025-09-20 05:45:00.699078307+00:00	2	3.299	-37	9.25
2025-09-20 06:05:00.480076673+00:00	2	3.299	-39	10.00
2025-09-20 06:25:00.259467290+00:00	2	3.299	-39	9.50

dds75-lb-12

received_at	f_port	battery	rssi	snr
2025-09-20 05:06:03.417406266+00:00	2	3.314	-45	9.50
2025-09-20 05:26:03.148929458+00:00	2	3.314	-44	8.75
2025-09-20 05:46:02.908945973+00:00	2	3.314	-41	10.00
2025-09-20 06:06:02.648483933+00:00	2	3.314	-43	10.00
2025-09-20 06:26:02.420499677+00:00	2	3.314	-41	7.25

dds75-lb-13

received_at	f_port	battery	rssi	snr
2025-09-20 05:07:16.351494446+00:00	2	3.291	-116	-0.50
2025-09-20 05:27:16.108281265+00:00	2	3.291	-119	-2.50
2025-09-20 05:47:15.859763285+00:00	2	3.291	-37	9.75
2025-09-20 06:07:15.621015805+00:00	2	3.291	-38	10.25
2025-09-20 06:27:15.379891163+00:00	2	3.291	-121	-7.50

dds75-lb-14

received_at	f_port	battery	rssi	snr
2025-09-20 05:22:07.229883385+00:00	2	3.286	-45	8.50
2025-09-20 05:42:07.007973543+00:00	2	3.286	-119	-3.50
2025-09-20 06:02:06.781159719+00:00	2	3.286	-51	10.75
2025-09-20 06:22:06.540859197+00:00	2	3.286	-51	9.25

dds75-lb-15

received_at	f_port	battery	rssi	snr
2025-09-20 05:23:05.686410427+00:00	2	3.343	-31	8.00
2025-09-20 05:43:05.439700625+00:00	2	3.343	-32	8.25
2025-09-20 06:03:05.214461901+00:00	2	3.343	-33	10.25
2025-09-20 06:23:04.957910345+00:00	2	3.343	-37	10.50

dds75-lb-16

received_at	f_port	battery	rssi	snr
2025-09-20 05:20:46.219763811+00:00	2	3.324	-47	7.50
2025-09-20 05:40:46.018772800+00:00	2	3.324	-47	9.00
2025-09-20 06:00:45.761328118+00:00	2	3.324	-45	9.25
2025-09-20 06:20:45.532923902+00:00	2	3.324	-45	9.75

dds75-lb-17

received_at	f_port	battery	rssi	snr
2025-09-20 05:23:37.719382768+00:00	2	3.277	-123	-7.25
2025-09-20 05:43:37.499228053+00:00	2	3.277	-33	7.50
2025-09-20 06:03:37.250405299+00:00	2	3.277	-35	7.25
2025-09-20 06:23:37.007375171+00:00	2	3.277	-37	10.00

dds75-lb-18

received_at	f_port	battery	rssi	snr
2025-09-20 05:21:15.660103373+00:00	2	3.327	-51	10.25
2025-09-20 05:41:15.439939030+00:00	2	3.327	-51	9.25
2025-09-20 06:01:15.209623411+00:00	2	3.327	-51	10.00
2025-09-20 06:21:14.972262525+00:00	2	3.327	-53	10.25

dds75-lb-19

received_at	f_port	battery	rssi	snr
2025-09-20 05:05:46.847440874+00:00	2	3.341	-114	-5.00
2025-09-20 05:25:46.617103833+00:00	2	3.341	-41	9.50
2025-09-20 05:45:46.379648904+00:00	2	3.341	-41	7.75
2025-09-20 06:05:46.110973956+00:00	2	3.341	-124	-10.25
2025-09-20 06:25:45.887455730+00:00	2	3.341	-115	0.25

dds75-lb-20

received_at	f_port	battery	rssi	snr
2025-09-20 05:23:34.859999083+00:00	2	3.268	-41	8.00
2025-09-20 05:43:34.626089009+00:00	2	3.268	-43	10.50
2025-09-20 06:03:34.411108448+00:00	2	3.268	-41	9.25
2025-09-20 06:23:34.201586633+00:00	2	3.268	-41	9.75

dds75-lb-21

received_at	f_port	battery	rssi	snr
2025-09-20 05:23:45.019608649+00:00	2	3.333	-33	10.00
2025-09-20 05:43:44.798657185+00:00	2	3.333	-35	9.75
2025-09-20 06:03:44.553315901+00:00	2	3.333	-32	8.00
2025-09-20 06:23:44.341631302+00:00	2	3.333	-116	-0.25

ps-lb-01

received_at	f_port	battery	rssi	snr
2025-09-20 05:13:15.479826574+00:00	2	3.303	-31	10.75
2025-09-20 05:23:15.351919805+00:00	2	3.303	-31	9.25
2025-09-20 05:33:15.226291010+00:00	2	3.303	-29	9.50
2025-09-20 05:43:15.126564103+00:00	2	3.303	-35	7.25
2025-09-20 05:53:15.012454170+00:00	2	3.303	-31	10.25
2025-09-20 06:03:14.891505249+00:00	2	3.303	-32	9.25
2025-09-20 06:13:14.763854846+00:00	2	3.303	-29	8.25
2025-09-20 06:23:14.650829609+00:00	2	3.303	-31	9.75
2025-09-20 06:33:14.528754029+00:00	2	3.303	-35	7.75

ps-lb-02

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:10.589200393+00:00	2	3.588	18.775	5.502	-21	9.75
2025-09-20 05:20:10.469390142+00:00	2	3.588	18.775	5.502	-24	7.50
2025-09-20 05:30:10.347040159+00:00	2	3.588	18.775	5.502	-21	9.50
2025-09-20 05:40:10.229732402+00:00	2	3.588	18.775	5.502	-24	9.50
2025-09-20 05:50:10.103012043+00:00	2	3.582	18.775	5.502	-24	6.75
2025-09-20 06:00:09.998000054+00:00	2	3.582	18.775	5.502	-19	9.50
2025-09-20 06:10:09.870383607+00:00	2	3.582	18.775	5.502	-24	9.25
2025-09-20 06:20:09.753637965+00:00	2	3.582	18.775	5.502	-21	10.25
2025-09-20 06:30:09.626771614+00:00	2	3.588	18.775	5.502	-116	-0.25

ps-lb-03

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:20.037099787+00:00	2	3.576	20.100	5.608	-25	10.00
2025-09-20 05:20:19.939396539+00:00	2	3.576	20.088	5.607	-25	9.00
2025-09-20 05:30:19.856450019+00:00	2	3.576	20.088	5.607	-24	9.75
2025-09-20 05:40:19.716789627+00:00	2	3.582	20.088	5.607	-25	10.00
2025-09-20 05:50:19.600555354+00:00	2	3.576	20.100	5.608	-28	8.00
2025-09-20 06:00:19.507116517+00:00	2	3.576	20.088	5.607	-119	-3.25
2025-09-20 06:10:19.370153868+00:00	2	3.576	20.088	5.607	-26	10.75
2025-09-20 06:20:19.274555385+00:00	2	3.582	20.088	5.607	-24	9.50
2025-09-20 06:30:19.158601420+00:00	2	3.576	20.088	5.607	-23	8.25

ps-lb-04

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:44.215252134+00:00	2	3.576	19.925	5.594	-24	9.25
2025-09-20 05:19:44.086988113+00:00	2	3.582	19.925	5.594	-20	8.75
2025-09-20 05:29:43.957002739+00:00	2	3.582	19.925	5.594	-117	-1.50
2025-09-20 05:39:43.826167094+00:00	2	3.582	19.925	5.594	-30	7.00
2025-09-20 05:49:43.713962718+00:00	2	3.576	19.925	5.594	-21	9.75
2025-09-20 05:59:43.608612247+00:00	2	3.576	19.925	5.594	-24	8.75
2025-09-20 06:09:43.490929760+00:00	2	3.576	19.913	5.593	-24	9.25
2025-09-20 06:19:43.370549279+00:00	2	3.576	19.913	5.593	-25	10.00
2025-09-20 06:29:43.250565020+00:00	2	3.582	19.913	5.593	-26	9.75

ps-lb-05

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:02.409916950+00:00	2	3.588	22.388	5.791	-39	9.25
2025-09-20 05:20:02.289276804+00:00	2	3.588	22.400	5.792	-41	7.75
2025-09-20 05:30:02.193307571+00:00	2	3.588	22.388	5.791	-39	7.75
2025-09-20 05:40:02.058697144+00:00	2	3.588	22.388	5.791	-41	10.00
2025-09-20 05:50:01.961746257+00:00	2	3.588	22.388	5.791	-109	6.00
2025-09-20 06:00:01.848956680+00:00	2	3.588	22.388	5.791	-39	9.50
2025-09-20 06:10:01.741661447+00:00	2	3.588	22.388	5.791	-39	9.25
2025-09-20 06:20:01.607856137+00:00	2	3.588	22.388	5.791	-113	1.25
2025-09-20 06:30:01.493713158+00:00	2	3.588	22.375	5.790	-41	7.00

ps-lb-06

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:41.899316869+00:00	2	3.576	20.350	5.628	-112	3.75
2025-09-20 05:19:41.787316911+00:00	2	3.576	20.350	5.628	-17	11.00
2025-09-20 05:29:41.664264140+00:00	2	3.576	20.350	5.628	-20	9.25
2025-09-20 05:39:41.536619925+00:00	2	3.576	20.350	5.628	-17	9.00
2025-09-20 05:49:41.430437425+00:00	2	3.576	20.350	5.628	-119	-10.75
2025-09-20 05:59:41.299721071+00:00	2	3.576	20.350	5.628	-17	7.75
2025-09-20 06:09:41.159534474+00:00	2	3.576	20.337	5.627	-15	9.50
2025-09-20 06:19:41.041727569+00:00	2	3.576	20.350	5.628	-17	10.50
2025-09-20 06:29:40.903496390+00:00	2	3.576	20.337	5.627	-20	10.25

ps-lb-07

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:57.559428978+00:00	2	3.552	20.025	5.602	-124	-7.50
2025-09-20 05:19:57.449112049+00:00	2	3.552	20.025	5.602	-20	9.50
2025-09-20 05:29:57.326736274+00:00	2	3.552	20.025	5.602	-25	9.00
2025-09-20 05:39:57.198974296+00:00	2	3.552	20.025	5.602	-23	7.75
2025-09-20 05:49:57.105525613+00:00	2	3.552	20.025	5.602	-21	9.50
2025-09-20 05:59:56.970919648+00:00	2	3.552	20.012	5.601	-25	9.25
2025-09-20 06:09:56.840403791+00:00	2	3.552	20.012	5.601	-20	9.00
2025-09-20 06:19:56.750807260+00:00	2	3.552	20.012	5.601	-21	10.50
2025-09-20 06:29:56.611408241+00:00	2	3.552	20.012	5.601	-23	11.00

ps-lb-08

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:31.070012787+00:00	2	3.564	20.775	5.662	-42	7.75
2025-09-20 05:19:30.938925486+00:00	2	3.570	20.775	5.662	-42	7.75
2025-09-20 05:29:30.828662008+00:00	2	3.570	20.775	5.662	-44	7.75
2025-09-20 05:39:30.707574560+00:00	2	3.564	20.775	5.662	-43	10.00
2025-09-20 05:49:30.582410071+00:00	2	3.570	20.775	5.662	-44	10.00
2025-09-20 05:59:30.470075298+00:00	2	3.570	20.775	5.662	-43	9.25
2025-09-20 06:09:30.349682778+00:00	2	3.570	20.775	5.662	-118	-2.50
2025-09-20 06:19:30.222538318+00:00	2	3.570	20.762	5.661	-43	9.00
2025-09-20 06:29:30.110606121+00:00	2	3.570	20.775	5.662	-119	-3.00

ps-lb-09

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:28.651521286+00:00	2	3.546	21.837	5.747	-41	9.75
2025-09-20 05:19:28.535844099+00:00	2	3.546	21.837	5.747	-40	9.00
2025-09-20 05:29:28.406975886+00:00	2	3.552	21.837	5.747	-39	7.25
2025-09-20 05:39:28.295372858+00:00	2	3.546	21.837	5.747	-39	9.50
2025-09-20 05:49:28.173070027+00:00	2	3.546	21.837	5.747	-121	-6.50
2025-09-20 05:59:28.050327882+00:00	2	3.546	21.825	5.746	-38	8.50
2025-09-20 06:09:27.953538424+00:00	2	3.546	21.825	5.746	-41	10.75
2025-09-20 06:19:27.837788777+00:00	2	3.546	21.825	5.746	-117	-2.00
2025-09-20 06:29:27.711038245+00:00	2	3.546	21.825	5.746	-38	9.00

ps-lb-10

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:05.326622190+00:00	2	3.564	19.512	5.561	-43	7.50
2025-09-20 05:20:05.207324804+00:00	2	3.564	19.512	5.561	-117	-0.25
2025-09-20 05:30:05.098879146+00:00	2	3.570	19.512	5.561	-43	9.50
2025-09-20 05:40:04.995312622+00:00	2	3.564	19.512	5.561	-43	9.00
2025-09-20 05:50:04.853516389+00:00	2	3.564	19.512	5.561	-41	7.25
2025-09-20 06:00:04.757527872+00:00	2	3.564	19.512	5.561	-115	0.75
2025-09-20 06:10:04.647534174+00:00	2	3.564	19.500	5.560	-44	9.50
2025-09-20 06:20:04.522467649+00:00	2	3.564	19.500	5.560	-41	7.25
2025-09-20 06:30:04.419033926+00:00	2	3.570	19.512	5.561	-123	-8.00

ps-lb-11

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:03.076136995+00:00	2	3.564	19.225	5.538	-44	10.00
2025-09-20 05:20:02.959472478+00:00	2	3.564	19.225	5.538	-117	-2.25
2025-09-20 05:30:02.867974182+00:00	2	3.564	19.225	5.538	-44	9.75
2025-09-20 05:40:02.716854939+00:00	2	3.564	19.225	5.538	-43	8.75
2025-09-20 05:50:02.604504103+00:00	2	3.564	19.225	5.538	-41	9.00
2025-09-20 06:00:02.480639838+00:00	2	3.564	19.225	5.538	-43	9.00
2025-09-20 06:10:02.370857743+00:00	2	3.564	19.225	5.538	-43	9.75
2025-09-20 06:20:02.229435790+00:00	2	3.564	19.225	5.538	-44	9.50
2025-09-20 06:30:02.121408880+00:00	2	3.564	19.225	5.538	-45	10.00

ps-lb-12

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:34.006593919+00:00	2	3.594	21.85	5.748	-121	-4.75
2025-09-20 05:19:33.879427172+00:00	2	3.594	21.85	5.748	-34	7.50
2025-09-20 05:29:33.758849028+00:00	2	3.594	21.85	5.748	-31	8.75
2025-09-20 05:39:33.637105388+00:00	2	3.594	21.85	5.748	-119	-2.50
2025-09-20 05:49:33.536840555+00:00	2	3.594	21.85	5.748	-32	9.75
2025-09-20 05:59:33.418585979+00:00	2	3.594	21.85	5.748	-31	9.50
2025-09-20 06:09:33.275447322+00:00	2	3.594	21.85	5.748	-33	10.75
2025-09-20 06:19:33.160419975+00:00	2	3.594	21.85	5.748	-33	9.50
2025-09-20 06:29:33.059890673+00:00	2	3.594	21.85	5.748	-121	-4.50

ps-lb-13

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:32:02.656213828+00:00	2	3.588	19.563	5.565	-51	9.00
2025-09-20 06:02:02.289730106+00:00	2	3.588	19.550	5.564	-122	-7.50
2025-09-20 06:32:01.927230180+00:00	2	3.588	19.537	5.563	-121	-6.75

ps-lb-14

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:09.353980698+00:00	2	3.57	18.100	5.448	-41	7.50
2025-09-20 05:20:09.236826392+00:00	2	3.57	18.088	5.447	-37	8.75
2025-09-20 05:30:09.108425661+00:00	2	3.57	18.088	5.447	-41	10.50
2025-09-20 05:40:09.009220049+00:00	2	3.57	18.088	5.447	-41	7.00
2025-09-20 05:50:08.900084855+00:00	2	3.57	18.088	5.447	-117	-1.00
2025-09-20 06:00:08.763385224+00:00	2	3.57	18.088	5.447	-39	9.25
2025-09-20 06:10:08.653194233+00:00	2	3.57	18.075	5.446	-37	7.50
2025-09-20 06:20:08.561124983+00:00	2	3.57	18.075	5.446	-38	7.50
2025-09-20 06:30:08.440714714+00:00	2	3.57	18.088	5.447	-41	6.75

ps-lb-15

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:59.046662101+00:00	2	3.57	21.050	5.684	-39	8.75
2025-09-20 05:19:58.938461887+00:00	2	3.57	21.062	5.685	-43	7.75
2025-09-20 05:29:58.801000851+00:00	2	3.57	21.050	5.684	-39	10.25
2025-09-20 05:39:58.680295116+00:00	2	3.57	21.050	5.684	-117	-1.00
2025-09-20 05:49:58.553572871+00:00	2	3.57	21.050	5.684	-41	10.25
2025-09-20 05:59:58.459791053+00:00	2	3.57	21.050	5.684	-41	10.75
2025-09-20 06:09:58.300378648+00:00	2	3.57	21.037	5.683	-43	7.00
2025-09-20 06:19:58.172279472+00:00	2	3.57	21.037	5.683	-38	9.50
2025-09-20 06:29:58.070399426+00:00	2	3.57	21.037	5.683	-43	10.00

ps-lb-16

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:00.746069904+00:00	2	3.564	20.163	5.613	-38	9.25
2025-09-20 05:20:00.617782705+00:00	2	3.564	20.163	5.613	-41	9.50
2025-09-20 05:30:00.513319583+00:00	2	3.564	20.163	5.613	-41	9.75
2025-09-20 05:40:00.382382865+00:00	2	3.564	20.163	5.613	-42	10.50
2025-09-20 05:50:00.260593496+00:00	2	3.564	20.163	5.613	-38	8.50
2025-09-20 06:00:00.151043112+00:00	2	3.564	20.163	5.613	-38	7.50
2025-09-20 06:10:00.024525513+00:00	2	3.564	20.150	5.612	-41	7.75
2025-09-20 06:19:59.931641522+00:00	2	3.564	20.163	5.613	-41	9.50
2025-09-20 06:29:59.798309023+00:00	2	3.564	20.163	5.613	-43	9.75

ps-lb-17

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 06:24:59.290424378+00:00	2	3.546	20.613	5.649	-57	10.25
2025-09-20 06:25:59.286081295+00:00	2	3.546	20.613	5.649	-63	7.75
2025-09-20 06:26:59.288909906+00:00	2	3.546	20.613	5.649	-61	9.00
2025-09-20 06:27:59.249067318+00:00	2	3.552	20.613	5.649	-61	9.75
2025-09-20 06:28:59.240676543+00:00	2	3.546	20.613	5.649	-57	10.25
2025-09-20 06:29:59.269555643+00:00	2	3.546	20.613	5.649	-120	-4.50
2025-09-20 06:30:59.231500146+00:00	2	3.546	20.613	5.649	-116	NaN
2025-09-20 06:31:59.203667585+00:00	2	3.546	20.613	5.649	-56	8.50
2025-09-20 06:32:59.208420344+00:00	2	3.546	20.613	5.649	-57	9.75
2025-09-20 06:33:59.200848090+00:00	2	3.552	20.613	5.649	-62	7.25
2025-09-20 06:34:59.198488892+00:00	2	3.546	20.613	5.649	-56	6.75
2025-09-20 06:35:59.175765311+00:00	2	3.546	20.613	5.649	-57	9.00

ps-lb-18

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:12:09.606605259+00:00	2	3.582	20.012	5.601	-31	7.50
2025-09-20 05:22:09.498962589+00:00	2	3.582	20.012	5.601	-29	10.50
2025-09-20 05:32:09.346596065+00:00	2	3.576	20.012	5.601	-29	9.75
2025-09-20 05:42:09.249597939+00:00	2	3.576	20.012	5.601	-31	9.50
2025-09-20 05:52:09.138819866+00:00	2	3.576	20.012	5.601	-27	10.25
2025-09-20 06:02:09.018637532+00:00	2	3.576	20.012	5.601	-116	-0.75
2025-09-20 06:12:08.901946773+00:00	2	3.582	20.012	5.601	-29	9.50
2025-09-20 06:22:08.770890653+00:00	2	3.576	20.012	5.601	-27	7.25
2025-09-20 06:32:08.648433710+00:00	2	3.582	20.000	5.600	-31	9.50

ps-lb-19

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:10:34.016353819+00:00	2	3.534	22.162	5.773	-35	9.25
2025-09-20 05:20:33.909390892+00:00	2	3.534	22.162	5.773	-35	10.25
2025-09-20 05:30:33.788463120+00:00	2	3.534	22.162	5.773	-35	7.75
2025-09-20 05:40:33.679190275+00:00	2	3.534	22.162	5.773	-35	7.00
2025-09-20 05:50:33.549895376+00:00	2	3.534	22.162	5.773	-114	1.50
2025-09-20 06:00:33.438464893+00:00	2	3.534	22.162	5.773	-35	10.25
2025-09-20 06:10:33.310871524+00:00	2	3.534	22.162	5.773	-37	11.25
2025-09-20 06:20:33.190882782+00:00	2	3.534	22.162	5.773	-35	9.50
2025-09-20 06:30:33.081679020+00:00	2	3.534	22.162	5.773	-38	9.50

ps-lb-20

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:14:05.879242083+00:00	2	3.594	20.737	5.659	-41	9.75
2025-09-20 05:24:05.758336724+00:00	2	3.594	20.800	5.664	-42	10.00
2025-09-20 05:34:05.657952657+00:00	2	3.594	20.850	5.668	-43	7.00
2025-09-20 05:44:05.549721326+00:00	2	3.588	20.875	5.670	-41	9.75
2025-09-20 05:54:05.422357257+00:00	2	3.588	20.900	5.672	-45	11.50
2025-09-20 06:04:05.289858789+00:00	2	3.594	20.825	5.666	-119	-5.25
2025-09-20 06:14:05.173732108+00:00	2	3.594	20.950	5.676	-41	9.75
2025-09-20 06:24:05.077728704+00:00	2	3.588	20.775	5.662	-117	-1.00
2025-09-20 06:34:04.962438466+00:00	2	3.594	20.662	5.653	-41	10.50

ps-lb-21

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 05:09:13.038866276+00:00	2	3.582	21.325	5.706	-35	9.25
2025-09-20 05:19:12.941243607+00:00	2	3.582	21.325	5.706	-33	7.25
2025-09-20 05:29:12.827252609+00:00	2	3.582	21.325	5.706	-111	4.00
2025-09-20 05:39:12.709482275+00:00	2	3.576	21.325	5.706	-33	8.50
2025-09-20 05:49:12.611144890+00:00	2	3.582	21.325	5.706	-112	2.75
2025-09-20 05:59:12.490786047+00:00	2	3.576	21.325	5.706	-35	10.00
2025-09-20 06:09:12.379988403+00:00	2	3.582	21.325	5.706	-33	9.50
2025-09-20 06:19:12.272174612+00:00	2	3.576	21.325	5.706	-35	9.25
2025-09-20 06:29:12.167984279+00:00	2	3.576	21.325	5.706	-31	7.50

sensecap-01

no recent data

Allgemeine Formate im Repo

NDJSON (Newline Delimited JSON)

Jede Zeile ein JSON-Objekt → ideal für Streaming & APIs.
Direkt auswertbar mit jq, pandas.read_json(..., lines=True), jsonlite::stream_in().

# bash / jq
head -n 3 data/<device>_raw.ndjson | jq .
# Python / pandas
import pandas as pd
df = pd.read_json("data/<device>_raw.ndjson", lines=True)

Hinweis: data/<device>_raw.ndjson enthält die rohen TTN-Storage-Antworten pro Pull (optional append/snapshot).

Parquet

Spaltenorientiert, binär, sehr kompakt & schnell.
Für Analysen/Abfragen optimiert – Standard in Spark, DuckDB, BigQuery etc.

# Python / pandas
import pandas as pd
df = pd.read_parquet("data/<device>.parquet")

Typischer Workflow: Rohdaten zuerst als NDJSON persistieren → für Analyse/Archiv in Parquet konvertieren.

CSV

Mensch- & toollesbar, maximal interoperabel (Excel, R, GIS, Shell).
Wird vom Script zusätzlich zu Parquet erzeugt: data/<device>.csv.

# Python / pandas (mit Timestamps)
import pandas as pd
df = pd.read_csv("data/<device>.csv", parse_dates=["received_at"])
# Schnellblick (Shell)
head -n 3 data/<device>.csv

Hinweis: Das Script **liest bevorzugt Parquet** (Performance). CSV dient als offenes Austauschformat und Fallback.

Sensoren & Felder

Sensor	Wichtige Felder
DDS75-LB (`dds75-lb-*.parquet`)	`distance_cm` (bzw. `Distance_mm`), `temperature`, `battery`, Flags: `interrupt_flag`, `sensor_flag`
PS-LB (`burgwald-ps-lb-*.parquet`)	`water_cm` bzw. `pressure_kpa`/`pressure_mpa`, zusätzlich `idc_input_ma`, `vdc_input_v`, `battery`, digitale Eingänge
SenseCAP (`burgwald-sensecap-*.parquet`)	`temperature`, `humidity`, `pressure_hpa`, `illumination`, ggf. `uv_index`, `wind_speed`, `wind_dir`, `rainfall`

Hinweis: Das Dashboard gruppiert Devices automatisch nach Sensor-Typ und zeigt Betriebswerte (Battery/RSSI/SNR/Power) in einem Sammel-Diagramm.

TTN Dashboard – Grouped by Sensor Type

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10

ps-lb-11

ps-lb-12

ps-lb-13

ps-lb-14

ps-lb-15

ps-lb-16

ps-lb-17

ps-lb-18

ps-lb-19

ps-lb-20

ps-lb-21

Geräte-Tabelle

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10